Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	26749
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	1431
Duplicate rows (%)	5.3%
Total size in memory	3.7 MiB
Average record size in memory	144.0 B

Variable types

Numeric	12
Categorical	6

Warnings

Dataset has 1431 (5.3%) duplicate rows	Duplicates
`artists` has a high cardinality: 11327 distinct values	High cardinality
`id` has a high cardinality: 25318 distinct values	High cardinality
`name` has a high cardinality: 22387 distinct values	High cardinality
`release_date` has a high cardinality: 2689 distinct values	High cardinality
`id` is uniformly distributed	Uniform
`name` is uniformly distributed	Uniform
`instrumentalness` has 8044 (30.1%) zeros	Zeros
`key` has 2983 (11.2%) zeros	Zeros

Reproduction

Analysis started	2021-03-12 00:36:41.045410
Analysis finished	2021-03-12 00:37:00.139107
Duration	19.09 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

acousticness
Real number (ℝ_≥0)

Distinct	4317
Distinct (%)	16.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.2255303994
Minimum	0
Maximum	0.996
Zeros	6
Zeros (%)	< 0.1%
Memory size	209.1 KiB

Quantile statistics

Minimum	0
5-th percentile	7.35 × 10⁵
Q1	0.00455
median	0.0658
Q3	0.36
95-th percentile	0.902
Maximum	0.996
Range	0.996
Interquartile range (IQR)	0.35545

Descriptive statistics

Standard deviation	0.2996601914
Coefficient of variation (CV)	1.328690909
Kurtosis	0.2423220524
Mean	0.2255303994
Median Absolute Deviation (MAD)	0.065548
Skewness	1.268799996
Sum	6032.712653
Variance	0.08979623033
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.101	58	0.2%
0.312	51	0.2%
0.114	43	0.2%
0.225	42	0.2%
0.124	42	0.2%
0.115	41	0.2%
0.113	38	0.1%
0.102	38	0.1%
0.162	37	0.1%
0.107	37	0.1%
Other values (4307)	26322	98.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6	< 0.1%
1.04 × 10⁶	2	< 0.1%
1.1 × 10⁶	3	< 0.1%
1.12 × 10⁶	1	< 0.1%
1.15 × 10⁶	1	< 0.1%

Value	Count	Frequency (%)
0.996	12	< 0.1%
0.995	15	0.1%
0.994	26	0.1%
0.993	26	0.1%
0.992	24	0.1%

artists
Categorical

HIGH CARDINALITY

Distinct	11327
Distinct (%)	42.3%
Missing	0
Missing (%)	0.0%
Memory size	209.1 KiB

['Armin van Buuren']	213
['Workout Music ']	203
['Taylor Swift']	151
['TandMProductionCo', 'TandMMusic', 'TandMTV']	150
['Roy Orbison', 'Alex Orbison', 'Chuck Turner']	146
Other values (11322)	25886

Length

Max length	242
Median length	17
Mean length	21.41137986
Min length	5

Characters and Unicode

Total characters	572733
Distinct characters	323
Distinct categories	17 ?
Distinct scripts	8 ?
Distinct blocks	10 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7915 ?
Unique (%)	29.6%

Sample

1st row	['Frank Sinatra']
2nd row	['Frank Sinatra']
3rd row	['Joni Mitchell']
4th row	['Joni Mitchell']
5th row	['Joni Mitchell']

Value	Count	Frequency (%)
['Armin van Buuren']	213	0.8%
['Workout Music ']	203	0.8%
['Taylor Swift']	151	0.6%
['TandMProductionCo', 'TandMMusic', 'TandMTV']	150	0.6%
['Roy Orbison', 'Alex Orbison', 'Chuck Turner']	146	0.5%
['Adam Gardner']	99	0.4%
['Charttraxx Karaoke']	96	0.4%
['David Bowie']	94	0.4%
['Hollywood Session Group']	91	0.3%
['Paul Carrack']	89	0.3%
Other values (11317)	25417	95.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
the	2132	3.0%
	832	1.2%
van	440	0.6%
dj	383	0.5%
music	382	0.5%
lil	366	0.5%
armin	350	0.5%
buuren	349	0.5%
orbison	299	0.4%
band	281	0.4%
Other values (12055)	65852	91.9%

Most occurring characters

Value	Count	Frequency (%)
'	73758	12.9%
	44918	7.8%
e	36159	6.3%
a	33798	5.9%
[	26752	4.7%
]	26752	4.7%
n	26188	4.6%
i	25405	4.4%
o	24566	4.3%
r	24302	4.2%
Other values (313)	230135	40.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	303083	52.9%
Other Punctuation	86690	15.1%
Uppercase Letter	79687	13.9%
Space Separator	44918	7.8%
Open Punctuation	26832	4.7%
Close Punctuation	26832	4.7%
Decimal Number	2019	0.4%
Other Letter	1483	0.3%
Dash Punctuation	548	0.1%
Nonspacing Mark	340	0.1%
Other values (7)	301	0.1%

Most frequent character per category

Value	Count	Frequency (%)
เ	143	9.6%
อ	139	9.4%
ร	124	8.4%
ย	106	7.1%
น	95	6.4%
ล	78	5.3%
ม	69	4.7%
ฟ	67	4.5%
ว	55	3.7%
ป	50	3.4%
Other values (150)	557	37.6%

Value	Count	Frequency (%)
e	36159	11.9%
a	33798	11.2%
n	26188	8.6%
i	25405	8.4%
o	24566	8.1%
r	24302	8.0%
l	17483	5.8%
s	15642	5.2%
t	15160	5.0%
u	10879	3.6%
Other values (54)	73501	24.3%

Value	Count	Frequency (%)
T	6573	8.2%
S	6453	8.1%
M	6298	7.9%
B	5756	7.2%
A	5266	6.6%
C	5219	6.5%
D	4507	5.7%
R	4088	5.1%
J	3854	4.8%
L	3638	4.6%
Other values (37)	28035	35.2%

Value	Count	Frequency (%)
'	73758	85.1%
,	10360	12.0%
.	1163	1.3%
&	603	0.7%
"	533	0.6%
!	145	0.2%
/	84	0.1%
:	14	< 0.1%
@	9	< 0.1%
%	7	< 0.1%
Other values (4)	14	< 0.1%

Value	Count	Frequency (%)
ิ	133	39.1%
์	90	26.5%
ี	59	17.4%
้	15	4.4%
ั	13	3.8%
ู	12	3.5%
๊	6	1.8%
็	5	1.5%
ุ	3	0.9%
่	3	0.9%

Value	Count	Frequency (%)
0	457	22.6%
2	374	18.5%
1	295	14.6%
9	160	7.9%
5	155	7.7%
8	149	7.4%
3	136	6.7%
4	130	6.4%
7	105	5.2%
6	58	2.9%

Value	Count	Frequency (%)
[	26752	99.7%
(	80	0.3%

Value	Count	Frequency (%)
]	26752	99.7%
)	80	0.3%

Value	Count	Frequency (%)
-	546	99.6%
〜	2	0.4%

Value	Count	Frequency (%)
®	2	66.7%
☆	1	33.3%

Value	Count	Frequency (%)
’	11	84.6%
”	2	15.4%

Value	Count	Frequency (%)
+	28	90.3%
\|	3	9.7%

Value	Count	Frequency (%)
	44918	100.0%

Value	Count	Frequency (%)
$	243	100.0%

Value	Count	Frequency (%)
ー	2	100.0%

Value	Count	Frequency (%)
_	8	100.0%

Value	Count	Frequency (%)
²	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	382725	66.8%
Common	188140	32.8%
Thai	1693	0.3%
Han	82	< 0.1%
Cyrillic	45	< 0.1%
Hangul	19	< 0.1%
Katakana	16	< 0.1%
Hiragana	13	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
e	36159	9.4%
a	33798	8.8%
n	26188	6.8%
i	25405	6.6%
o	24566	6.4%
r	24302	6.3%
l	17483	4.6%
s	15642	4.1%
t	15160	4.0%
u	10879	2.8%
Other values (76)	153143	40.0%

Value	Count	Frequency (%)
田	2	2.4%
美	2	2.4%
林	2	2.4%
遠	1	1.2%
野	1	1.2%
高	1	1.2%
志	1	1.2%
加	1	1.2%
島	1	1.2%
優	1	1.2%
Other values (69)	69	84.1%

Value	Count	Frequency (%)
เ	143	8.4%
อ	139	8.2%
ิ	133	7.9%
ร	124	7.3%
ย	106	6.3%
น	95	5.6%
์	90	5.3%
ล	78	4.6%
ม	69	4.1%
ฟ	67	4.0%
Other values (38)	649	38.3%

Value	Count	Frequency (%)
'	73758	39.2%
	44918	23.9%
[	26752	14.2%
]	26752	14.2%
,	10360	5.5%
.	1163	0.6%
&	603	0.3%
-	546	0.3%
"	533	0.3%
0	457	0.2%
Other values (31)	2298	1.2%

Value	Count	Frequency (%)
е	5	11.1%
о	4	8.9%
а	4	8.9%
з	3	6.7%
Ч	2	4.4%
б	2	4.4%
П	2	4.4%
т	2	4.4%
р	2	4.4%
н	2	4.4%
Other values (15)	17	37.8%

Value	Count	Frequency (%)
나	2	10.5%
율	2	10.5%
시	1	5.3%
온	1	5.3%
한	1	5.3%
해	1	5.3%
팬	1	5.3%
텀	1	5.3%
미	1	5.3%
스	1	5.3%
Other values (7)	7	36.8%

Value	Count	Frequency (%)
ジ	1	6.2%
ミ	1	6.2%
シ	1	6.2%
リ	1	6.2%
ズ	1	6.2%
ヒ	1	6.2%
ソ	1	6.2%
カ	1	6.2%
ハ	1	6.2%
セ	1	6.2%
Other values (6)	6	37.5%

Value	Count	Frequency (%)
ま	2	15.4%
や	2	15.4%
る	1	7.7%
た	1	7.7%
つ	1	7.7%
あ	1	7.7%
べ	1	7.7%
と	1	7.7%
も	1	7.7%
な	1	7.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	570184	99.6%
Thai	1693	0.3%
None	664	0.1%
CJK	82	< 0.1%
Cyrillic	45	< 0.1%
Hangul	19	< 0.1%
Katakana	18	< 0.1%
Punctuation	14	< 0.1%
Hiragana	13	< 0.1%
Misc Symbols	1	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
'	73758	12.9%
	44918	7.9%
e	36159	6.3%
a	33798	5.9%
[	26752	4.7%
]	26752	4.7%
n	26188	4.6%
i	25405	4.5%
o	24566	4.3%
r	24302	4.3%
Other values (75)	227586	39.9%

Value	Count	Frequency (%)
é	261	39.3%
á	80	12.0%
ö	49	7.4%
ä	32	4.8%
ç	28	4.2%
ú	28	4.2%
ü	22	3.3%
å	22	3.3%
ë	21	3.2%
ó	19	2.9%
Other values (27)	102	15.4%

Value	Count	Frequency (%)
เ	143	8.4%
อ	139	8.2%
ิ	133	7.9%
ร	124	7.3%
ย	106	6.3%
น	95	5.6%
์	90	5.3%
ล	78	4.6%
ม	69	4.1%
ฟ	67	4.0%
Other values (38)	649	38.3%

Value	Count	Frequency (%)
’	11	78.6%
”	2	14.3%
•	1	7.1%

Value	Count	Frequency (%)
나	2	10.5%
율	2	10.5%
시	1	5.3%
온	1	5.3%
한	1	5.3%
해	1	5.3%
팬	1	5.3%
텀	1	5.3%
미	1	5.3%
스	1	5.3%
Other values (7)	7	36.8%

Value	Count	Frequency (%)
田	2	2.4%
美	2	2.4%
林	2	2.4%
遠	1	1.2%
野	1	1.2%
高	1	1.2%
志	1	1.2%
加	1	1.2%
島	1	1.2%
優	1	1.2%
Other values (69)	69	84.1%

Value	Count	Frequency (%)
ー	2	11.1%
ジ	1	5.6%
ミ	1	5.6%
シ	1	5.6%
リ	1	5.6%
ズ	1	5.6%
ヒ	1	5.6%
ソ	1	5.6%
カ	1	5.6%
ハ	1	5.6%
Other values (7)	7	38.9%

Value	Count	Frequency (%)
е	5	11.1%
о	4	8.9%
а	4	8.9%
з	3	6.7%
Ч	2	4.4%
б	2	4.4%
П	2	4.4%
т	2	4.4%
р	2	4.4%
н	2	4.4%
Other values (15)	17	37.8%

Value	Count	Frequency (%)
ま	2	15.4%
や	2	15.4%
る	1	7.7%
た	1	7.7%
つ	1	7.7%
あ	1	7.7%
べ	1	7.7%
と	1	7.7%
も	1	7.7%
な	1	7.7%

Value	Count	Frequency (%)
☆	1	100.0%

danceability
Real number (ℝ_≥0)

Distinct	967
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.5884334405
Minimum	0
Maximum	0.986
Zeros	41
Zeros (%)	0.2%
Memory size	209.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.272
Q1	0.479
median	0.599
Q3	0.718
95-th percentile	0.843
Maximum	0.986
Range	0.986
Interquartile range (IQR)	0.239

Descriptive statistics

Standard deviation	0.1732731783
Coefficient of variation (CV)	0.2944652128
Kurtosis	-0.03826221572
Mean	0.5884334405
Median Absolute Deviation (MAD)	0.119
Skewness	-0.4436758264
Sum	15740.0061
Variance	0.03002359431
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.675	88	0.3%
0.654	85	0.3%
0.599	83	0.3%
0.614	82	0.3%
0.651	82	0.3%
0.495	81	0.3%
0.671	80	0.3%
0.628	79	0.3%
0.547	79	0.3%
0.808	78	0.3%
Other values (957)	25932	96.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	41	0.2%
0.0551	1	< 0.1%
0.0559	2	< 0.1%
0.0574	1	< 0.1%
0.0586	1	< 0.1%

Value	Count	Frequency (%)
0.986	1	< 0.1%
0.985	3	< 0.1%
0.982	1	< 0.1%
0.98	1	< 0.1%
0.975	3	< 0.1%

duration_ms
Real number (ℝ_≥0)

Distinct	19282
Distinct (%)	72.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	250088.7271
Minimum	4937
Maximum	5338302
Zeros	0
Zeros (%)	0.0%
Memory size	209.1 KiB

Quantile statistics

Minimum	4937
5-th percentile	79693.6
Q1	182720
median	222093
Q3	276772
95-th percentile	454473.2
Maximum	5338302
Range	5333365
Interquartile range (IQR)	94052

Descriptive statistics

Standard deviation	216250.5807
Coefficient of variation (CV)	0.8646954351
Kurtosis	219.2182467
Mean	250088.7271
Median Absolute Deviation (MAD)	45294
Skewness	12.71520995
Sum	6689623361
Variance	4.676431365 × 10¹⁰
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
253000	39	0.1%
49000	34	0.1%
150000	31	0.1%
343125	31	0.1%
360000	24	0.1%
240000	19	0.1%
264000	18	0.1%
213600	17	0.1%
180000	16	0.1%
228000	16	0.1%
Other values (19272)	26504	99.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4937	1	< 0.1%
8042	1	< 0.1%
12000	1	< 0.1%
12759	1	< 0.1%
13284	1	< 0.1%

Value	Count	Frequency (%)
5338302	1	< 0.1%
5042185	1	< 0.1%
4800118	2	< 0.1%
4792587	1	< 0.1%
4737458	1	< 0.1%

energy
Real number (ℝ_≥0)

Distinct	1310
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.6607594601
Minimum	2.01 × 10⁵
Maximum	1
Zeros	0
Zeros (%)	0.0%
Memory size	209.1 KiB

Quantile statistics

Minimum	2.01 × 10⁵
5-th percentile	0.208
Q1	0.506
median	0.695
Q3	0.857
95-th percentile	0.973
Maximum	1
Range	0.9999799
Interquartile range (IQR)	0.351

Descriptive statistics

Standard deviation	0.2357790534
Coefficient of variation (CV)	0.3568303863
Kurtosis	-0.2997741321
Mean	0.6607594601
Median Absolute Deviation (MAD)	0.173
Skewness	-0.6335123128
Sum	17674.6548
Variance	0.05559176203
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.726	78	0.3%
0.979	75	0.3%
0.856	68	0.3%
0.691	68	0.3%
0.95	67	0.3%
0.97	66	0.2%
0.868	65	0.2%
0.961	63	0.2%
0.949	63	0.2%
0.872	62	0.2%
Other values (1300)	26074	97.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.01 × 10⁵	3	< 0.1%
2.03 × 10⁵	3	< 0.1%
4.28 × 10⁵	1	< 0.1%
4.98 × 10⁵	1	< 0.1%
6.19 × 10⁵	2	< 0.1%

Value	Count	Frequency (%)
1	17	0.1%
0.999	51	0.2%
0.998	61	0.2%
0.997	59	0.2%
0.996	52	0.2%

explicit
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	209.1 KiB

0	22186
1	4563

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	26749
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	22186	82.9%
1	4563	17.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	22186	82.9%
1	4563	17.1%

Most occurring characters

Value	Count	Frequency (%)
0	22186	82.9%
1	4563	17.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	26749	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	22186	82.9%
1	4563	17.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	26749	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	22186	82.9%
1	4563	17.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	26749	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	22186	82.9%
1	4563	17.1%

id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	25318
Distinct (%)	94.7%
Missing	0
Missing (%)	0.0%
Memory size	209.1 KiB

0UsmyJDsst2xhX1ZiFF3JW	9
7tH6tGz6cQtpYReqHTlyjN	8
7Kh32CyazzTdVEBXjKINVO	8
58lQgf1Y5gRJRr6S0Nwp50	7
7FmPp4BjDVaEwhsEO7B7Oe	7
Other values (25313)	26710

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	588478
Distinct characters	62
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24033 ?
Unique (%)	89.8%

Sample

1st row	1hx7X9cMXHWJjknb9O6Ava
2nd row	19oquvXf3bc65GSqtPYA5S
3rd row	55qyghODi24yaDgKBI6lx0
4th row	00xemFYjQNRpOlPhVaLAHa
5th row	2lm5FQJRHvc3rUN5YHpEWj

Value	Count	Frequency (%)
0UsmyJDsst2xhX1ZiFF3JW	9	< 0.1%
7tH6tGz6cQtpYReqHTlyjN	8	< 0.1%
7Kh32CyazzTdVEBXjKINVO	8	< 0.1%
58lQgf1Y5gRJRr6S0Nwp50	7	< 0.1%
7FmPp4BjDVaEwhsEO7B7Oe	7	< 0.1%
00ohIpPn9LkKpeIqhfIU9V	7	< 0.1%
5rJw9VsPNdfnV9Ar97xZG2	7	< 0.1%
4KoDsg2EbYPgqpXSrKqB7F	6	< 0.1%
0QXEvVJyHIQhVzci6kBULo	6	< 0.1%
0Io1kinEi9fp1b4Maf84yO	6	< 0.1%
Other values (25308)	26678	99.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
0usmyjdsst2xhx1ziff3jw	9	< 0.1%
7th6tgz6cqtpyreqhtlyjn	8	< 0.1%
7kh32cyazztdvebxjkinvo	8	< 0.1%
00ohippn9lkkpeiqhfiu9v	7	< 0.1%
7fmpp4bjdvaewhseo7b7oe	7	< 0.1%
5rjw9vspndfnv9ar97xzg2	7	< 0.1%
58lqgf1y5grjrr6s0nwp50	7	< 0.1%
0io1kinei9fp1b4maf84yo	6	< 0.1%
0qxevvjyhiqhvzci6kbulo	6	< 0.1%
0sbb2st9txikbkqw7xuzrw	6	< 0.1%
Other values (25308)	26678	99.7%

Most occurring characters

Value	Count	Frequency (%)
0	12612	2.1%
6	12558	2.1%
5	12548	2.1%
4	12418	2.1%
3	12416	2.1%
2	12413	2.1%
1	12304	2.1%
7	11772	2.0%
s	9253	1.6%
d	9243	1.6%
Other values (52)	470941	80.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	235835	40.1%
Uppercase Letter	235546	40.0%
Decimal Number	117097	19.9%

Most frequent character per category

Value	Count	Frequency (%)
s	9253	3.9%
d	9243	3.9%
t	9181	3.9%
q	9178	3.9%
f	9160	3.9%
r	9145	3.9%
y	9144	3.9%
h	9141	3.9%
b	9133	3.9%
p	9129	3.9%
Other values (16)	144128	61.1%

Value	Count	Frequency (%)
K	9198	3.9%
F	9187	3.9%
T	9178	3.9%
X	9177	3.9%
J	9169	3.9%
S	9167	3.9%
B	9152	3.9%
L	9141	3.9%
D	9137	3.9%
C	9121	3.9%
Other values (16)	143919	61.1%

Value	Count	Frequency (%)
0	12612	10.8%
6	12558	10.7%
5	12548	10.7%
4	12418	10.6%
3	12416	10.6%
2	12413	10.6%
1	12304	10.5%
7	11772	10.1%
9	9049	7.7%
8	9007	7.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	471381	80.1%
Common	117097	19.9%

Most frequent character per script

Value	Count	Frequency (%)
s	9253	2.0%
d	9243	2.0%
K	9198	2.0%
F	9187	1.9%
t	9181	1.9%
q	9178	1.9%
T	9178	1.9%
X	9177	1.9%
J	9169	1.9%
S	9167	1.9%
Other values (42)	379450	80.5%

Value	Count	Frequency (%)
0	12612	10.8%
6	12558	10.7%
5	12548	10.7%
4	12418	10.6%
3	12416	10.6%
2	12413	10.6%
1	12304	10.5%
7	11772	10.1%
9	9049	7.7%
8	9007	7.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	588478	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	12612	2.1%
6	12558	2.1%
5	12548	2.1%
4	12418	2.1%
3	12416	2.1%
2	12413	2.1%
1	12304	2.1%
7	11772	2.0%
s	9253	1.6%
d	9243	1.6%
Other values (52)	470941	80.0%

instrumentalness
Real number (ℝ_≥0)

ZEROS

Distinct	4379
Distinct (%)	16.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.2349304515
Minimum	0
Maximum	1
Zeros	8044
Zeros (%)	30.1%
Memory size	209.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.000452
Q3	0.531
95-th percentile	0.92
Maximum	1
Range	1
Interquartile range (IQR)	0.531

Descriptive statistics

Standard deviation	0.3600561842
Coefficient of variation (CV)	1.532607552
Kurtosis	-0.6421174068
Mean	0.2349304515
Median Absolute Deviation (MAD)	0.000452
Skewness	1.08064318
Sum	6284.154647
Variance	0.1296404558
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8044	30.1%
0.911	65	0.2%
0.873	52	0.2%
0.901	51	0.2%
0.91	45	0.2%
0.905	45	0.2%
0.897	43	0.2%
0.907	42	0.2%
0.902	42	0.2%
0.917	41	0.2%
Other values (4369)	18279	68.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8044	30.1%
1 × 10⁶	6	< 0.1%
1.01 × 10⁶	9	< 0.1%
1.02 × 10⁶	9	< 0.1%
1.03 × 10⁶	9	< 0.1%

Value	Count	Frequency (%)
1	7	< 0.1%
0.999	4	< 0.1%
0.998	5	< 0.1%
0.997	4	< 0.1%
0.996	5	< 0.1%

key
Real number (ℝ_≥0)

ZEROS

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.327601032
Minimum	0
Maximum	11
Zeros	2983
Zeros (%)	11.2%
Memory size	209.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	6
Q3	9
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.590069426
Coefficient of variation (CV)	0.6738622889
Kurtosis	-1.298771024
Mean	5.327601032
Median Absolute Deviation (MAD)	3
Skewness	-0.01421274094
Sum	142508
Variance	12.88859848
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	3102	11.6%
0	2983	11.2%
1	2886	10.8%
9	2672	10.0%
2	2584	9.7%
11	2263	8.5%
4	2067	7.7%
5	2038	7.6%
6	1980	7.4%
10	1807	6.8%
Other values (2)	2367	8.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2983	11.2%
1	2886	10.8%
2	2584	9.7%
3	709	2.7%
4	2067	7.7%

Value	Count	Frequency (%)
11	2263	8.5%
10	1807	6.8%
9	2672	10.0%
8	1658	6.2%
7	3102	11.6%

liveness
Real number (ℝ_≥0)

Distinct	1633
Distinct (%)	6.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.220280717
Minimum	0
Maximum	0.993
Zeros	3
Zeros (%)	< 0.1%
Memory size	209.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0585
Q1	0.0967
median	0.133
Q3	0.294
95-th percentile	0.687
Maximum	0.993
Range	0.993
Interquartile range (IQR)	0.1973

Descriptive statistics

Standard deviation	0.1950971367
Coefficient of variation (CV)	0.8856750576
Kurtosis	3.229991072
Mean	0.220280717
Median Absolute Deviation (MAD)	0.055
Skewness	1.8760515
Sum	5892.2889
Variance	0.03806289277
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.111	311	1.2%
0.11	268	1.0%
0.109	263	1.0%
0.112	259	1.0%
0.106	257	1.0%
0.107	257	1.0%
0.108	252	0.9%
0.105	246	0.9%
0.102	235	0.9%
0.103	216	0.8%
Other values (1623)	24185	90.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	< 0.1%
0.0119	1	< 0.1%
0.0142	1	< 0.1%
0.0147	1	< 0.1%
0.0164	1	< 0.1%

Value	Count	Frequency (%)
0.993	2	< 0.1%
0.992	2	< 0.1%
0.991	4	< 0.1%
0.99	3	< 0.1%
0.988	3	< 0.1%

loudness
Real number (ℝ)

Distinct	10965
Distinct (%)	41.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-8.176739766
Minimum	-54.376
Maximum	3.367
Zeros	0
Zeros (%)	0.0%
Memory size	209.1 KiB

Quantile statistics

Minimum	-54.376
5-th percentile	-16.6002
Q1	-9.643
median	-7.146
Q3	-5.403
95-th percentile	-3.362
Maximum	3.367
Range	57.743
Interquartile range (IQR)	4.24

Descriptive statistics

Standard deviation	4.471252872
Coefficient of variation (CV)	-0.5468258744
Kurtosis	8.220659585
Mean	-8.176739766
Median Absolute Deviation (MAD)	2.004
Skewness	-2.230982979
Sum	-218719.612
Variance	19.99210225
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-7.578	33	0.1%
-3.304	32	0.1%
-8.705	28	0.1%
-7.031	22	0.1%
-5.702	21	0.1%
-10.438	16	0.1%
-12.552	15	0.1%
-6.594	14	0.1%
-7.256	14	0.1%
-2.093	13	< 0.1%
Other values (10955)	26541	99.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-54.376	1	< 0.1%
-47.731	1	< 0.1%
-45.353	1	< 0.1%
-44.761	1	< 0.1%
-44.281	1	< 0.1%

Value	Count	Frequency (%)
3.367	1	< 0.1%
1.027	5	< 0.1%
1.023	1	< 0.1%
0.977	1	< 0.1%
0.899	1	< 0.1%

mode
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	209.1 KiB

1	16700
0	10049

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	26749
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	16700	62.4%
0	10049	37.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	16700	62.4%
0	10049	37.6%

Most occurring characters

Value	Count	Frequency (%)
1	16700	62.4%
0	10049	37.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	26749	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	16700	62.4%
0	10049	37.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	26749	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	16700	62.4%
0	10049	37.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	26749	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	16700	62.4%
0	10049	37.6%

name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	22387
Distinct (%)	83.7%
Missing	0
Missing (%)	0.0%
Memory size	209.1 KiB

Happy New Year	50
2000 Years	49
99 Year Blues	44
7 Years	36
My Only Wish (This Year)	36
Other values (22382)	26534

Length

Max length	197
Median length	19
Mean length	22.94149314
Min length	1

Characters and Unicode

Total characters	613662
Distinct characters	527
Distinct categories	18 ?
Distinct scripts	10 ?
Distinct blocks	13 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19552 ?
Unique (%)	73.1%

Sample

1st row	The September Of My Years - Live At The Sands Hotel And Casino, Las Vegas/1966 / Show 2
2nd row	It Was A Very Good Year - Live At The Sands Hotel And Casino, Las Vegas/1966 / Show 2
3rd row	The Circle Game - Live at The 2nd Fret, Philadelphia, PA, 11/1966
4th row	Urge For Going - Live at The 2nd Fret, Philadelphia, PA, 11/1966
5th row	What's The Story Mr. Blue - Live at The 2nd Fret, Philadelphia, PA, 11/1966

Value	Count	Frequency (%)
Happy New Year	50	0.2%
2000 Years	49	0.2%
99 Year Blues	44	0.2%
7 Years	36	0.1%
My Only Wish (This Year)	36	0.1%
It's the Most Wonderful Time of the Year	33	0.1%
New Years Day - Original Mix	32	0.1%
New Year	23	0.1%
Year 2000	19	0.1%
99 Year Blues - Live	16	0.1%
Other values (22377)	26411	98.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
	8613	7.5%
the	3451	3.0%
mix	2599	2.3%
year	1793	1.6%
of	1720	1.5%
remix	1562	1.4%
feat	1340	1.2%
you	1198	1.0%
years	1183	1.0%
a	1170	1.0%
Other values (15088)	90651	78.6%

Most occurring characters

Value	Count	Frequency (%)
	88531	14.4%
e	54122	8.8%
a	34245	5.6%
i	31794	5.2%
o	29610	4.8%
r	27729	4.5%
n	25924	4.2%
t	25820	4.2%
s	18978	3.1%
l	16216	2.6%
Other values (517)	260693	42.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	367140	59.8%
Uppercase Letter	97626	15.9%
Space Separator	88531	14.4%
Decimal Number	27336	4.5%
Other Punctuation	9756	1.6%
Dash Punctuation	7919	1.3%
Close Punctuation	5669	0.9%
Open Punctuation	5667	0.9%
Other Letter	2937	0.5%
Nonspacing Mark	598	0.1%
Other values (8)	483	0.1%

Most frequent character per category

Value	Count	Frequency (%)
า	196	6.7%
น	162	5.5%
เ	160	5.4%
ก	147	5.0%
ร	142	4.8%
ม	130	4.4%
อ	129	4.4%
ไ	100	3.4%
ง	98	3.3%
ห	90	3.1%
Other values (284)	1583	53.9%

Value	Count	Frequency (%)
e	54122	14.7%
a	34245	9.3%
i	31794	8.7%
o	29610	8.1%
r	27729	7.6%
n	25924	7.1%
t	25820	7.0%
s	18978	5.2%
l	16216	4.4%
h	12341	3.4%
Other values (89)	90361	24.6%

Value	Count	Frequency (%)
M	8625	8.8%
T	7735	7.9%
S	7214	7.4%
R	6796	7.0%
Y	5792	5.9%
L	5305	5.4%
A	5235	5.4%
B	4962	5.1%
O	4860	5.0%
C	4823	4.9%
Other values (47)	36279	37.2%

Value	Count	Frequency (%)
.	2988	30.6%
'	2077	21.3%
,	1906	19.5%
&	704	7.2%
/	584	6.0%
:	420	4.3%
"	396	4.1%
!	229	2.3%
#	158	1.6%
?	113	1.2%
Other values (11)	181	1.9%

Value	Count	Frequency (%)
่	176	29.4%
ั	105	17.6%
้	97	16.2%
ี	69	11.5%
ิ	37	6.2%
ื	25	4.2%
็	23	3.8%
ู	22	3.7%
ุ	19	3.2%
์	14	2.3%
Other values (2)	11	1.8%

Value	Count	Frequency (%)
0	8511	31.1%
2	7006	25.6%
1	5029	18.4%
9	1374	5.0%
5	1153	4.2%
4	917	3.4%
8	886	3.2%
7	847	3.1%
6	841	3.1%
3	772	2.8%

Value	Count	Frequency (%)
+	188	89.5%
~	13	6.2%
\|	3	1.4%
>	2	1.0%
=	2	1.0%
<	2	1.0%

Value	Count	Frequency (%)
(	5304	93.6%
[	360	6.4%
⧼	1	< 0.1%
『	1	< 0.1%
{	1	< 0.1%

Value	Count	Frequency (%)
)	5304	93.6%
]	362	6.4%
⧽	1	< 0.1%
』	1	< 0.1%
}	1	< 0.1%

Value	Count	Frequency (%)
-	7899	99.7%
〜	10	0.1%
–	8	0.1%
—	2	< 0.1%

Value	Count	Frequency (%)
°	1	33.3%
♥	1	33.3%
®	1	33.3%

Value	Count	Frequency (%)
’	134	93.7%
”	9	6.3%

Value	Count	Frequency (%)
“	9	81.8%
‘	2	18.2%

Value	Count	Frequency (%)
ー	15	78.9%
ๆ	4	21.1%

Value	Count	Frequency (%)
´	5	83.3%
`	1	16.7%

Value	Count	Frequency (%)
	88531	100.0%

Value	Count	Frequency (%)
$	83	100.0%

Value	Count	Frequency (%)
_	8	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	464374	75.7%
Common	145357	23.7%
Thai	2980	0.5%
Cyrillic	374	0.1%
Han	173	< 0.1%
Katakana	171	< 0.1%
Hiragana	120	< 0.1%
Hangul	94	< 0.1%
Georgian	18	< 0.1%
Inherited	1	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
e	54122	11.7%
a	34245	7.4%
i	31794	6.8%
o	29610	6.4%
r	27729	6.0%
n	25924	5.6%
t	25820	5.6%
s	18978	4.1%
l	16216	3.5%
h	12341	2.7%
Other values (92)	187595	40.4%

Value	Count	Frequency (%)
九	14	8.1%
段	14	8.1%
教	14	8.1%
会	14	8.1%
愛	4	2.3%
年	4	2.3%
時	4	2.3%
君	3	1.7%
日	3	1.7%
夜	3	1.7%
Other values (79)	96	55.5%

Value	Count	Frequency (%)
해	4	4.3%
월	4	4.3%
년	3	3.2%
새	3	3.2%
복	3	3.2%
소	2	2.1%
을	2	2.1%
로	2	2.1%
거	2	2.1%
의	2	2.1%
Other values (57)	67	71.3%

Value	Count	Frequency (%)
	88531	60.9%
0	8511	5.9%
-	7899	5.4%
2	7006	4.8%
(	5304	3.6%
)	5304	3.6%
1	5029	3.5%
.	2988	2.1%
'	2077	1.4%
,	1906	1.3%
Other values (54)	10802	7.4%

Value	Count	Frequency (%)
า	196	6.6%
่	176	5.9%
น	162	5.4%
เ	160	5.4%
ก	147	4.9%
ร	142	4.8%
ม	130	4.4%
อ	129	4.3%
ั	105	3.5%
ไ	100	3.4%
Other values (47)	1533	51.4%

Value	Count	Frequency (%)
イ	16	9.4%
ル	11	6.4%
ク	9	5.3%
ン	9	5.3%
ア	7	4.1%
ウ	7	4.1%
ッ	6	3.5%
ト	5	2.9%
バ	5	2.9%
ェ	5	2.9%
Other values (40)	91	53.2%

Value	Count	Frequency (%)
а	43	11.5%
н	28	7.5%
о	27	7.2%
и	26	7.0%
е	25	6.7%
р	18	4.8%
к	16	4.3%
д	13	3.5%
л	12	3.2%
с	11	2.9%
Other values (38)	155	41.4%

Value	Count	Frequency (%)
の	14	11.7%
し	8	6.7%
な	6	5.0%
い	6	5.0%
ら	5	4.2%
か	5	4.2%
た	5	4.2%
ね	4	3.3%
は	4	3.3%
こ	4	3.3%
Other values (33)	59	49.2%

Value	Count	Frequency (%)
ა	6	33.3%
ნ	4	22.2%
მ	2	11.1%
ე	2	11.1%
ტ	2	11.1%
ი	2	11.1%

Value	Count	Frequency (%)
́	1	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	608989	99.2%
Thai	2980	0.5%
None	547	0.1%
Cyrillic	374	0.1%
Katakana	193	< 0.1%
CJK	173	< 0.1%
Punctuation	170	< 0.1%
Hiragana	120	< 0.1%
Hangul	94	< 0.1%
Georgian	18	< 0.1%
Other values (3)	4	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
	88531	14.5%
e	54122	8.9%
a	34245	5.6%
i	31794	5.2%
o	29610	4.9%
r	27729	4.6%
n	25924	4.3%
t	25820	4.2%
s	18978	3.1%
l	16216	2.7%
Other values (84)	256020	42.0%

Value	Count	Frequency (%)
é	111	20.3%
á	46	8.4%
ü	42	7.7%
ó	35	6.4%
ä	30	5.5%
í	30	5.5%
ö	26	4.8%
ç	25	4.6%
ñ	22	4.0%
ú	20	3.7%
Other values (49)	160	29.3%

Value	Count	Frequency (%)
’	134	78.8%
“	9	5.3%
”	9	5.3%
–	8	4.7%
…	4	2.4%
‘	2	1.2%
—	2	1.2%
•	2	1.2%

Value	Count	Frequency (%)
า	196	6.6%
่	176	5.9%
น	162	5.4%
เ	160	5.4%
ก	147	4.9%
ร	142	4.8%
ม	130	4.4%
อ	129	4.3%
ั	105	3.5%
ไ	100	3.4%
Other values (47)	1533	51.4%

Value	Count	Frequency (%)
九	14	8.1%
段	14	8.1%
教	14	8.1%
会	14	8.1%
愛	4	2.3%
年	4	2.3%
時	4	2.3%
君	3	1.7%
日	3	1.7%
夜	3	1.7%
Other values (79)	96	55.5%

Value	Count	Frequency (%)
の	14	11.7%
し	8	6.7%
な	6	5.0%
い	6	5.0%
ら	5	4.2%
か	5	4.2%
た	5	4.2%
ね	4	3.3%
は	4	3.3%
こ	4	3.3%
Other values (33)	59	49.2%

Value	Count	Frequency (%)
해	4	4.3%
월	4	4.3%
년	3	3.2%
새	3	3.2%
복	3	3.2%
소	2	2.1%
을	2	2.1%
로	2	2.1%
거	2	2.1%
의	2	2.1%
Other values (57)	67	71.3%

Value	Count	Frequency (%)
а	43	11.5%
н	28	7.5%
о	27	7.2%
и	26	7.0%
е	25	6.7%
р	18	4.8%
к	16	4.3%
д	13	3.5%
л	12	3.2%
с	11	2.9%
Other values (38)	155	41.4%

Value	Count	Frequency (%)
イ	16	8.3%
ー	15	7.8%
ル	11	5.7%
ク	9	4.7%
ン	9	4.7%
ア	7	3.6%
ウ	7	3.6%
・	7	3.6%
ッ	6	3.1%
ト	5	2.6%
Other values (42)	101	52.3%

Value	Count	Frequency (%)
ụ	1	50.0%
ầ	1	50.0%

Value	Count	Frequency (%)
ა	6	33.3%
ნ	4	22.2%
მ	2	11.1%
ე	2	11.1%
ტ	2	11.1%
ი	2	11.1%

Value	Count	Frequency (%)
♥	1	100.0%

Value	Count	Frequency (%)
́	1	100.0%

release_date
Categorical

HIGH CARDINALITY

Distinct	2689
Distinct (%)	10.1%
Missing	0
Missing (%)	0.0%
Memory size	209.1 KiB

2020-12-11	346
2010-01-01	340
2011-01-01	316
2013-01-01	287
2012-01-01	274
Other values (2684)	25186

Length

Max length	10
Median length	10
Mean length	9.831993719
Min length	4

Characters and Unicode

Total characters	262996
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	717 ?
Unique (%)	2.7%

Sample

1st row	2018-05-04
2nd row	2018-05-04
3rd row	2020-10-30
4th row	2020-10-30
5th row	2020-10-30

Value	Count	Frequency (%)
2020-12-11	346	1.3%
2010-01-01	340	1.3%
2011-01-01	316	1.2%
2013-01-01	287	1.1%
2012-01-01	274	1.0%
2019-12-13	260	1.0%
2017-12-15	227	0.8%
2014-12-19	192	0.7%
2018-12-14	185	0.7%
2020-12-23	182	0.7%
Other values (2679)	24140	90.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-12-11	346	1.3%
2010-01-01	340	1.3%
2011-01-01	316	1.2%
2013-01-01	287	1.1%
2012-01-01	274	1.0%
2019-12-13	260	1.0%
2017-12-15	227	0.8%
2014-12-19	192	0.7%
2018-12-14	185	0.7%
2020-12-23	182	0.7%
Other values (2679)	24140	90.2%

Most occurring characters

Value	Count	Frequency (%)
0	60833	23.1%
1	54366	20.7%
-	52000	19.8%
2	50075	19.0%
3	7914	3.0%
6	6674	2.5%
9	6637	2.5%
5	6479	2.5%
8	6345	2.4%
4	5840	2.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	210996	80.2%
Dash Punctuation	52000	19.8%

Most frequent character per category

Value	Count	Frequency (%)
0	60833	28.8%
1	54366	25.8%
2	50075	23.7%
3	7914	3.8%
6	6674	3.2%
9	6637	3.1%
5	6479	3.1%
8	6345	3.0%
4	5840	2.8%
7	5833	2.8%

Value	Count	Frequency (%)
-	52000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	262996	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	60833	23.1%
1	54366	20.7%
-	52000	19.8%
2	50075	19.0%
3	7914	3.0%
6	6674	2.5%
9	6637	2.5%
5	6479	2.5%
8	6345	2.4%
4	5840	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	262996	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	60833	23.1%
1	54366	20.7%
-	52000	19.8%
2	50075	19.0%
3	7914	3.0%
6	6674	2.5%
9	6637	2.5%
5	6479	2.5%
8	6345	2.4%
4	5840	2.2%

speechiness
Real number (ℝ_≥0)

Distinct	1373
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.09536206961
Minimum	0
Maximum	0.962
Zeros	41
Zeros (%)	0.2%
Memory size	209.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0285
Q1	0.0377
median	0.0534
Q3	0.0973
95-th percentile	0.324
Maximum	0.962
Range	0.962
Interquartile range (IQR)	0.0596

Descriptive statistics

Standard deviation	0.1099780594
Coefficient of variation (CV)	1.153268379
Kurtosis	15.91914327
Mean	0.09536206961
Median Absolute Deviation (MAD)	0.0198
Skewness	3.403954661
Sum	2550.84
Variance	0.01209517355
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0318	81	0.3%
0.0362	81	0.3%
0.0324	79	0.3%
0.0337	78	0.3%
0.0334	76	0.3%
0.0308	73	0.3%
0.0316	73	0.3%
0.0299	72	0.3%
0.0457	72	0.3%
0.102	71	0.3%
Other values (1363)	25993	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	41	0.2%
0.0224	1	< 0.1%
0.0226	1	< 0.1%
0.0227	1	< 0.1%
0.0229	2	< 0.1%

Value	Count	Frequency (%)
0.962	3	< 0.1%
0.961	2	< 0.1%
0.96	1	< 0.1%
0.959	1	< 0.1%
0.958	2	< 0.1%

tempo
Real number (ℝ_≥0)

Distinct	16188
Distinct (%)	60.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	123.3657748
Minimum	0
Maximum	221.954
Zeros	41
Zeros (%)	0.2%
Memory size	209.1 KiB

Quantile statistics

Minimum	0
5-th percentile	79.1362
Q1	104.39
median	126.031
Q3	138.041
95-th percentile	171.558
Maximum	221.954
Range	221.954
Interquartile range (IQR)	33.651

Descriptive statistics

Standard deviation	26.9124751
Coefficient of variation (CV)	0.2181518752
Kurtosis	0.5419374643
Mean	123.3657748
Median Absolute Deviation (MAD)	15.282
Skewness	0.001004568883
Sum	3299911.109
Variance	724.2813161
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
128.003	52	0.2%
0	41	0.2%
127.998	37	0.1%
128	36	0.1%
128.008	36	0.1%
130.007	36	0.1%
128.013	35	0.1%
128.01	34	0.1%
127.991	33	0.1%
127.992	32	0.1%
Other values (16178)	26377	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	41	0.2%
35.702	1	< 0.1%
36.97	1	< 0.1%
43.509	1	< 0.1%
46.18	1	< 0.1%

Value	Count	Frequency (%)
221.954	1	< 0.1%
220.099	1	< 0.1%
219.971	1	< 0.1%
219.86	1	< 0.1%
219.833	1	< 0.1%

valence
Real number (ℝ_≥0)

Distinct	1552
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4525039916
Minimum	0
Maximum	0.997
Zeros	43
Zeros (%)	0.2%
Memory size	209.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0688
Q1	0.249
median	0.438
Q3	0.643
95-th percentile	0.883
Maximum	0.997
Range	0.997
Interquartile range (IQR)	0.394

Descriptive statistics

Standard deviation	0.2488990754
Coefficient of variation (CV)	0.5500483533
Kurtosis	-0.9168295398
Mean	0.4525039916
Median Absolute Deviation (MAD)	0.197
Skewness	0.1842376677
Sum	12104.02927
Variance	0.06195074975
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.35	57	0.2%
0.34	56	0.2%
0.227	54	0.2%
0.451	53	0.2%
0.385	53	0.2%
0.351	52	0.2%
0.294	52	0.2%
0.661	51	0.2%
0.129	51	0.2%
0.398	51	0.2%
Other values (1542)	26219	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	43	0.2%
1 × 10⁵	28	0.1%
0.00173	1	< 0.1%
0.00228	1	< 0.1%
0.00298	1	< 0.1%

Value	Count	Frequency (%)
0.997	1	< 0.1%
0.99	1	< 0.1%
0.983	3	< 0.1%
0.982	2	< 0.1%
0.981	3	< 0.1%

year
Real number (ℝ_≥0)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2015.566713
Minimum	2010
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Memory size	209.1 KiB

Quantile statistics

Minimum	2010
5-th percentile	2010
Q1	2013
median	2016
Q3	2018
95-th percentile	2020
Maximum	2020
Range	10
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.234435768
Coefficient of variation (CV)	0.001604727716
Kurtosis	-1.222648871
Mean	2015.566713
Median Absolute Deviation (MAD)	3
Skewness	-0.1538197645
Sum	53914394
Variance	10.46157474
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
2020	4294	16.1%
2018	2714	10.1%
2013	2622	9.8%
2016	2349	8.8%
2019	2329	8.7%
2015	2300	8.6%
2014	2252	8.4%
2017	2156	8.1%
2010	1961	7.3%
2012	1959	7.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2010	1961	7.3%
2011	1813	6.8%
2012	1959	7.3%
2013	2622	9.8%
2014	2252	8.4%

Value	Count	Frequency (%)
2020	4294	16.1%
2019	2329	8.7%
2018	2714	10.1%
2017	2156	8.1%
2016	2349	8.8%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	acousticness	artists	danceability	duration_ms	energy	id	instrumentalness	key	liveness	loudness	mode	name	release_date	speechiness	tempo	valence	year
0	0.887	['Frank Sinatra']	0.319	187333	0.201	1hx7X9cMXHWJjknb9O6Ava	0.000000	7	0.9040	-17.796	1	The September Of My Years - Live At The Sands Hotel And Casino, Las Vegas/1966 / Show 2	2018-05-04	0.0623	117.153	0.239	2018
1	0.938	['Frank Sinatra']	0.269	236800	0.129	19oquvXf3bc65GSqtPYA5S	0.000005	7	0.6830	-18.168	0	It Was A Very Good Year - Live At The Sands Hotel And Casino, Las Vegas/1966 / Show 2	2018-05-04	0.0576	82.332	0.160	2018
2	0.881	['Joni Mitchell']	0.644	313093	0.212	55qyghODi24yaDgKBI6lx0	0.000022	11	0.7980	-14.118	1	The Circle Game - Live at The 2nd Fret, Philadelphia, PA, 11/1966	2020-10-30	0.0347	117.072	0.441	2020
3	0.955	['Joni Mitchell']	0.627	295093	0.184	00xemFYjQNRpOlPhVaLAHa	0.000162	1	0.0986	-15.533	1	Urge For Going - Live at The 2nd Fret, Philadelphia, PA, 11/1966	2020-10-30	0.0450	115.864	0.299	2020
4	0.888	['Joni Mitchell']	0.581	183440	0.331	2lm5FQJRHvc3rUN5YHpEWj	0.000015	6	0.1470	-14.087	1	What's The Story Mr. Blue - Live at The 2nd Fret, Philadelphia, PA, 11/1966	2020-10-30	0.2430	88.303	0.642	2020
5	0.930	['Joni Mitchell']	0.442	147907	0.399	26g4FBGTB9YEj7q4HlblFf	0.000499	6	0.9120	-12.661	1	Brandy Eyes - Live at The 2nd Fret, Philadelphia, PA, 11/1966	2020-10-30	0.0780	121.662	0.554	2020
6	0.949	['Joni Mitchell']	0.570	64173	0.176	05sxkljafFBW2vEnVczQy1	0.000000	6	0.1470	-22.676	0	Intro To Urge For Going - Live at The 2nd Fret, Philadelphia, PA, 11/1966	2020-10-30	0.2990	135.687	0.348	2020
7	0.911	['Joni Mitchell']	0.565	232640	0.153	4JyPPRoW8y6mA3XA7gKvoL	0.000000	10	0.3580	-21.606	0	Intro To The Circle Game - Live at The 2nd Fret, Philadelphia, PA, 11/1966	2020-10-30	0.3780	103.309	0.434	2020
8	0.932	['Joni Mitchell']	0.598	233520	0.212	0GohHD8bn4lP83agkBvi5i	0.000023	6	0.6920	-15.078	0	Eastern Rain - Live at The 2nd Fret, Philadelphia, PA, 11/1966	2020-10-30	0.0406	107.183	0.172	2020
9	0.879	['Joni Mitchell']	0.367	213840	0.307	7JnIimk8J3H1o828YLgZJT	0.000000	11	0.7300	-12.420	0	Night In The City - Live at The 2nd Fret, Philadelphia, PA, 11/1966	2020-10-30	0.0568	172.867	0.284	2020

Last rows

	acousticness	artists	danceability	duration_ms	energy	explicit	id	instrumentalness	key	liveness	loudness	mode	name	release_date	speechiness	tempo	valence	year
26739	0.00516	['Febration']	0.665	183307	0.926	0	4QRXELBqRwQQjd366OG1Do	0.004280	1	0.1240	-4.571	1	Forever In Paradise	2020-12-25	0.0651	126.914	0.1280	2020
26740	0.28500	['Roger Fly']	0.817	205438	0.511	0	5RrQPoB3UQ4LYSi0v5O3WA	0.901000	8	0.0945	-9.525	1	Saturday	2020-12-09	0.0477	102.231	0.8640	2020
26741	0.02230	['BigBankCarti']	0.796	148512	0.662	1	3MZ6J3lqRpSKX5lmbSaQVn	0.000000	11	0.3990	-6.793	1	Snot Thot	2020-12-31	0.2930	96.955	0.4620	2020
26742	0.01350	['Denis Pimenov']	0.770	211069	0.683	0	3kJINDNpUxwXuS2vVdCpOu	0.866000	5	0.1020	-6.007	0	Periscope	2020-12-05	0.0488	120.020	0.0971	2020
26743	0.01560	['Elyamont', 'Cristina Soto']	0.708	191341	0.849	0	54NeJ65oDIydq9jr0b8qjg	0.000000	0	0.1460	-2.579	1	Signals - Radio Edit	2020-12-25	0.0457	123.052	0.4520	2020
26744	0.04840	['Stephan F', 'YA-YA']	0.693	177148	0.826	0	1Cbf6PLWsL4s51eFepXx6L	0.000012	1	0.2310	-2.669	1	Only Tonight - Radio Edit	2020-12-25	0.0762	126.049	0.3610	2020
26745	0.14100	['BigBankCarti', 'Keyvo400']	0.544	215014	0.407	1	3ASGdyWXeXsXtOIWtm0tv4	0.000000	4	0.2530	-12.745	0	LayUp	2020-12-31	0.2330	129.750	0.4900	2020
26746	0.00917	['DJ Combo', 'Sander-7', 'Tony T']	0.792	147615	0.866	0	46LhBf6TvYjZU2SMvGZAbn	0.000060	6	0.1780	-5.089	0	The One	2020-12-25	0.0356	125.972	0.1860	2020
26747	0.80600	['Roger Fly']	0.671	218147	0.589	0	48Qj61hOdYmUCFJbpQ29Ob	0.920000	4	0.1130	-12.393	0	Together	2020-12-09	0.0282	108.058	0.7140	2020
26748	0.23900	['Roger Fly']	0.677	197710	0.460	0	57tgYkWQTNHVFEt6xDKKZj	0.891000	7	0.2150	-12.237	1	Improvisations	2020-12-09	0.0258	112.208	0.7470	2020

Most frequent

	acousticness	artists	danceability	duration_ms	energy	explicit	id	instrumentalness	key	liveness	loudness	mode	name	release_date	speechiness	tempo	valence	year	count
1250	0.969000	['Schoolgirl Byebye']	0.314	74302	0.0855	0	0UsmyJDsst2xhX1ZiFF3JW	0.795000	9	0.160	-15.775	1	Year,2015	2020-09-16	0.0342	69.893	0.161	2020	9
425	0.004990	['Armin van Buuren']	0.397	36500	0.6380	0	7tH6tGz6cQtpYReqHTlyjN	0.000000	2	0.364	-7.256	1	A State Of Trance (ASOT 996) - Tune Of The Year 2019 Top 3, Pt. 2	2020-12-24	0.1760	134.284	0.677	2020	8
617	0.023600	['Armin van Buuren']	0.542	33800	0.7940	0	7Kh32CyazzTdVEBXjKINVO	0.000000	7	0.148	-6.413	1	A State Of Trance (ASOT 996) - Tune Of The Year 2019 Top 3, Pt. 1	2020-12-24	0.3030	143.377	0.810	2020	8
240	0.000717	['Suffused', 'MSZ']	0.585	457306	0.8660	0	7FmPp4BjDVaEwhsEO7B7Oe	0.846000	9	0.159	-6.126	0	Year 2008 - MSZ Remix	2020-01-06	0.0340	127.009	0.450	2020	7
987	0.397000	['Anthem Lights']	0.390	182288	0.4550	0	5rJw9VsPNdfnV9Ar97xZG2	0.000000	4	0.125	-4.247	1	K-LOVE Fan Awards: Songs of the Year (2015 Mash-Up)	2015-03-31	0.0316	107.012	0.358	2015	7
1155	0.829000	['Anthem Lights']	0.420	213165	0.2810	0	00ohIpPn9LkKpeIqhfIU9V	0.000000	11	0.376	-8.204	1	K-Love Fan Awards: Songs of the Year (2014 Mash-Up)	2014-03-04	0.0334	119.515	0.229	2014	7
1166	0.843000	['The Kiboomers']	0.903	89655	0.2620	0	58lQgf1Y5gRJRr6S0Nwp50	0.000000	2	0.109	-12.528	1	The Months of the Year - 2014 Version	2015-08-01	0.0810	95.098	0.681	2015	7
316	0.001570	['Matias Grandom']	0.693	194508	0.3870	0	0QXEvVJyHIQhVzci6kBULo	0.588000	9	0.108	-13.820	1	Year 2000	2019-02-22	0.0520	129.968	0.282	2019	6
415	0.004400	['Riff Raff']	0.773	121500	0.8590	1	4KoDsg2EbYPgqpXSrKqB7F	0.007110	2	0.117	-6.459	1	Rookie of the Year 2013	2013-06-25	0.0573	159.955	0.577	2013	6
875	0.196000	['APRE']	0.651	237778	0.8900	0	0Sbb2ST9tXiKBkQw7XUZrw	0.000072	0	0.301	-4.745	0	Gap Year 2008	2019-03-29	0.0563	149.979	0.866	2019	6

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent